<?php
function getChargesUe()
{
	$req = pg_query("SELECT c.nomcharge as nomcharge,c.nbhrcharge as nbHeure,u.nomue as nomUe,e.nomens as nomEns,e.prenomens as prenomens FROM ue u,charge c,enseignant e  WHERE  u.idue = c.idue AND c.idresponsable=e.idenseignant");
	
	return $req;
	
}

function getChargesNoUe()
{
	$req = pg_query("SELECT c.nomcharge as nomcharge,c.nbhrcharge as nbHeure,e.nomens as nomEns,e.prenomens as prenomens FROM charge c,enseignant e  WHERE  c.idue IS NULL AND c.idresponsable=e.idenseignant");
	
	return $req;
	
}
?>
